from datetime import datetime

from openpyxl import load_workbook

# 加载现有文件
wb = load_workbook('test2.xlsx')
ws = wb.active

ws['A1'] = 'Hello'
# 往下一行写入数据
ws.append(['World', 2, 3.0])
ws['A3'] = datetime.now().strftime('%Y-%m-%d')
# 保存
wb.save('test2.xlsx')



